N per X

Use the N per X tool to take N records from every distinct value of X, where X is a column in the database.

For example, this tool is commonly used to select one record for every unique household ID to ensure that only one qualifying person per household is selected in a segment:

• Sampling Tools
  • Distributed Sample
  • N per X
    • Selecting N records from every distinct value of X
    • Selecting N records from every distinct value of X using the greater value of a Sort Column
    • Select lesser values of an N record from every distinct value of X
  • N Row Sample
  • One in N
  • Random Sample